CREATE DATABASE  IF NOT EXISTS `medicinamuncii` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_romanian_ci */;
USE `medicinamuncii`;
-- MySQL dump 10.13  Distrib 5.1.40, for Win32 (ia32)
--
-- Host: 127.0.0.1    Database: medicinamuncii
-- ------------------------------------------------------
-- Server version	5.1.51-community

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `companyinsult`
--

DROP TABLE IF EXISTS `companyinsult`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `companyinsult` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `CompanyID` int(11) NOT NULL,
  `InsultID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_Company_CompanyInsults` (`CompanyID`),
  KEY `FK_Insult_CompanyInsult` (`InsultID`),
  CONSTRAINT `FK_Company_CompanyInsults` FOREIGN KEY (`CompanyID`) REFERENCES `company` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_Insult_CompanyInsult` FOREIGN KEY (`InsultID`) REFERENCES `insult` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `companyinsult`
--

LOCK TABLES `companyinsult` WRITE;
/*!40000 ALTER TABLE `companyinsult` DISABLE KEYS */;
/*!40000 ALTER TABLE `companyinsult` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `examinationtype`
--

DROP TABLE IF EXISTS `examinationtype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `examinationtype` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(45) COLLATE utf8_romanian_ci NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `examinationtype`
--

LOCK TABLES `examinationtype` WRITE;
/*!40000 ALTER TABLE `examinationtype` DISABLE KEYS */;
INSERT INTO `examinationtype` VALUES (1,'Angajare'),(2,'Control medical periodic'),(3,'Adaptare'),(4,'Reluarea muncii'),(5,'Supraveghere specială'),(6,'Altele');
/*!40000 ALTER TABLE `examinationtype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `company`
--

DROP TABLE IF EXISTS `company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(60) COLLATE utf8_romanian_ci NOT NULL,
  `AddressID` int(11) DEFAULT NULL,
  `ContactPersonID` int(11) DEFAULT NULL,
  `Profile` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  `Unit` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_Address_Company` (`AddressID`),
  CONSTRAINT `FK_Address_Company` FOREIGN KEY (`AddressID`) REFERENCES `address` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company`
--

LOCK TABLES `company` WRITE;
/*!40000 ALTER TABLE `company` DISABLE KEYS */;
INSERT INTO `company` VALUES (1,'Companie 1',1,NULL,'profil 111','unitate 111'),(2,'Companie 2',1,NULL,'profil2','unitate2'),(3,'tre',9,NULL,NULL,NULL),(4,'tre',9,NULL,NULL,NULL),(5,'vcxdfsdf',10,NULL,NULL,NULL),(6,'vcxdfsdf',10,NULL,NULL,NULL),(7,'ewqeqw',11,NULL,NULL,NULL),(8,'ewqeqw',11,NULL,NULL,NULL),(9,'jhg',12,NULL,NULL,NULL),(10,'jhg',12,NULL,NULL,NULL),(11,'nbcv',13,NULL,NULL,NULL),(12,'oiuoi',14,NULL,NULL,NULL),(13,'ggdsf',15,NULL,NULL,NULL),(14,'gfdgfdgf',16,NULL,NULL,NULL),(15,'gfdgfdgf',16,NULL,NULL,NULL),(16,'vcx',17,NULL,NULL,NULL),(17,'vcx',17,NULL,NULL,NULL),(18,'dsadsa',18,NULL,NULL,NULL),(19,'dsadsa',19,NULL,NULL,NULL),(20,'dsadsa',20,NULL,NULL,NULL),(21,'tretererwf',21,NULL,NULL,NULL),(22,'tretererwf',22,NULL,NULL,NULL),(23,'ytryrt',23,NULL,NULL,NULL),(26,'mkjlkjkl',26,NULL,NULL,NULL),(27,'vcx',27,NULL,NULL,NULL),(28,'trete',28,NULL,NULL,NULL),(29,'oipo',29,NULL,NULL,NULL),(30,'rewrewrew',30,NULL,NULL,NULL),(31,'czxcxz',31,NULL,NULL,NULL),(34,'vcxvcxvcxvcxcvcvx',34,NULL,NULL,NULL),(35,'fdasfdas',42,NULL,NULL,NULL),(37,'hgdfhgfrefd',45,NULL,'fdsa','fdsa'),(38,'Companie n',46,NULL,'p1','u1'),(41,'test create',66,NULL,NULL,NULL),(43,'dsadsa',68,NULL,NULL,NULL),(44,'dsadasdsa',71,NULL,'dsadsa','dasdas');
/*!40000 ALTER TABLE `company` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recomandation`
--

DROP TABLE IF EXISTS `recomandation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recomandation` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recomandation`
--

LOCK TABLES `recomandation` WRITE;
/*!40000 ALTER TABLE `recomandation` DISABLE KEYS */;
INSERT INTO `recomandation` VALUES (1,'Monitorizare'),(2,'Supraveghere'),(3,'Purtare echipament'),(4,'Tratament'),(5,'Hodină cât cuprinde');
/*!40000 ALTER TABLE `recomandation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `insult`
--

DROP TABLE IF EXISTS `insult`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `insult` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(45) COLLATE utf8_romanian_ci NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `insult`
--

LOCK TABLES `insult` WRITE;
/*!40000 ALTER TABLE `insult` DISABLE KEYS */;
INSERT INTO `insult` VALUES (1,'n1');
/*!40000 ALTER TABLE `insult` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `person`
--

DROP TABLE IF EXISTS `person`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `FirstName` varchar(45) COLLATE utf8_romanian_ci NOT NULL,
  `LastName` varchar(45) COLLATE utf8_romanian_ci NOT NULL,
  `AddressID` int(11) DEFAULT NULL,
  `CNP` varchar(10) COLLATE utf8_romanian_ci DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_Address_Person` (`AddressID`),
  CONSTRAINT `FK_Address_Person` FOREIGN KEY (`AddressID`) REFERENCES `address` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `person`
--

LOCK TABLES `person` WRITE;
/*!40000 ALTER TABLE `person` DISABLE KEYS */;
INSERT INTO `person` VALUES (1,'John','Smith',NULL,'1234567890'),(2,'dsadsa','cxz',NULL,NULL),(3,'rewrewrwe','erwrerew',58,'342'),(4,'rewrewrwe','erwrerew',59,'342'),(5,'fdsa','fdas',60,'4343'),(6,'fdasfdas','fdasfds',61,'3223'),(7,'fdasfdas','fdasfds',62,'3223'),(8,'fdas','fdas',63,'43'),(9,'tretretre','tretertretr',64,'432432'),(10,'vcxvx','vcxvcx',65,'34423'),(11,'mos','mikulash',70,'123');
/*!40000 ALTER TABLE `person` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `examination`
--

DROP TABLE IF EXISTS `examination`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `examination` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ExaminationTypeID` int(11) NOT NULL,
  `MedicalAdviceID` int(11) NOT NULL,
  `EmployeeID` int(11) NOT NULL,
  `Date` datetime NOT NULL,
  `Recomandations` varchar(100) COLLATE utf8_romanian_ci DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_Employee_Examination` (`EmployeeID`),
  KEY `FK_MedicalAdvice_Examination` (`MedicalAdviceID`),
  KEY `FK_ExaminationType_Examination` (`ExaminationTypeID`),
  CONSTRAINT `FK_Employee_Examination` FOREIGN KEY (`EmployeeID`) REFERENCES `employee` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_ExaminationType_Examination` FOREIGN KEY (`ExaminationTypeID`) REFERENCES `examinationtype` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_MedicalAdvice_Examination` FOREIGN KEY (`MedicalAdviceID`) REFERENCES `medicaladvice` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `examination`
--

LOCK TABLES `examination` WRITE;
/*!40000 ALTER TABLE `examination` DISABLE KEYS */;
INSERT INTO `examination` VALUES (2,1,1,2,'2010-10-25 00:00:00','abcd...'),(3,3,2,2,'2010-11-01 00:00:00','hodina'),(4,3,3,2,'2010-11-21 00:00:00','dsa'),(5,1,1,11,'2010-11-30 21:25:24',NULL),(6,1,1,10,'2010-11-30 21:25:31',NULL),(7,1,1,11,'2010-11-30 22:05:47',NULL),(8,1,1,11,'2010-11-30 22:08:58',NULL),(9,1,1,10,'2010-11-30 22:13:23',NULL),(12,5,4,10,'2010-12-01 22:01:22',NULL),(13,5,4,10,'2010-12-01 22:01:50',NULL);
/*!40000 ALTER TABLE `examination` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `address`
--

DROP TABLE IF EXISTS `address`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Street` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  `Number` int(11) DEFAULT NULL,
  `Details` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  `City` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  `Country` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  `ZipCode` int(11) DEFAULT NULL,
  `Phone` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  `Fax` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  `Email` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `address`
--

LOCK TABLES `address` WRITE;
/*!40000 ALTER TABLE `address` DISABLE KEYS */;
INSERT INTO `address` VALUES (1,'horia',2,'bloc X1 scara n','Cluj-Napoca','Romania',400123,'123456','0264-124532','sergiu@yahoo.com'),(2,'sadsa',32,'dsa',NULL,NULL,NULL,NULL,NULL,NULL),(3,'dsadfs',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'dsadfs',NULL,'dsa',NULL,NULL,NULL,NULL,NULL,NULL),(5,'dsadsa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'wqewq',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'rew',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'fsd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'tregfd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'gfdsgfds',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'tre',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'gdf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'hgfhgf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'klkjl',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'vcxdfsds',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'dgfd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'vcx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'cxzcxz',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'cxzcxz',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'cxzcxz',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'dsfds',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'dsfds',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'gdfgdf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'xvcxvcx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'xvcxvcx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'oipoi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'vcx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'gfdgdf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'eqweq',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'qweweq',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'ewq',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'cbvc',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'fasfas',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'xvc',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'treter',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'fadsfds',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'ffdsfds',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'vczxvczx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'bvvc',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'gfdsgsd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'vcxvcxvcxvxc',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'vcxvcx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'def',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'safdasfdas',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'def12',789,'def',NULL,NULL,NULL,NULL,NULL,NULL),(47,'dddddeeeeeef123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'abcdefghi1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'adresa creat',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'tst',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'dsadas',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'test1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'polu nord*',123,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'dsadas',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employee`
--

DROP TABLE IF EXISTS `employee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `CompanyID` int(11) NOT NULL,
  `PersonID` int(11) NOT NULL,
  `Number` int(11) DEFAULT NULL,
  `Occupation` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  `Position` varchar(45) COLLATE utf8_romanian_ci DEFAULT NULL,
  `WorkPlace` varchar(60) COLLATE utf8_romanian_ci DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_Company_Employee` (`CompanyID`),
  KEY `FK_Person_Employee` (`PersonID`),
  CONSTRAINT `FK_Company_Employee` FOREIGN KEY (`CompanyID`) REFERENCES `company` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_Person_Employee` FOREIGN KEY (`PersonID`) REFERENCES `person` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee`
--

LOCK TABLES `employee` WRITE;
/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
INSERT INTO `employee` VALUES (2,1,1,1234,'pierde-vara','sef',NULL),(10,2,10,NULL,'sfdasfdas','fsdf','fdsafd'),(11,2,11,1,'nimic','ceva tat face',NULL);
/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `medicaladvice`
--

DROP TABLE IF EXISTS `medicaladvice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `medicaladvice` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(45) COLLATE utf8_romanian_ci NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `medicaladvice`
--

LOCK TABLES `medicaladvice` WRITE;
/*!40000 ALTER TABLE `medicaladvice` DISABLE KEYS */;
INSERT INTO `medicaladvice` VALUES (1,'APT'),(2,'APT CONDIȚIONAT'),(3,'INAPT TEMPORAR'),(4,'INAPT');
/*!40000 ALTER TABLE `medicaladvice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `examinationrecomandation`
--

DROP TABLE IF EXISTS `examinationrecomandation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `examinationrecomandation` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ExaminationID` int(11) NOT NULL,
  `RecomandationID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_Examination_ExaminationRecomandation` (`ExaminationID`),
  KEY `FK_Recomandation_ExaminationRecomandation` (`RecomandationID`),
  CONSTRAINT `FK_Examination_ExaminationRecomandation` FOREIGN KEY (`ExaminationID`) REFERENCES `examination` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_Recomandation_ExaminationRecomandation` FOREIGN KEY (`RecomandationID`) REFERENCES `recomandation` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `examinationrecomandation`
--

LOCK TABLES `examinationrecomandation` WRITE;
/*!40000 ALTER TABLE `examinationrecomandation` DISABLE KEYS */;
INSERT INTO `examinationrecomandation` VALUES (1,13,2);
/*!40000 ALTER TABLE `examinationrecomandation` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-12-01 23:48:52
